Overview

Brought to you by YData

Dataset statistics

Number of variables	23
Number of observations	141250
Missing cells	893520
Missing cells (%)	27.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	130.1 MiB
Average record size in memory	965.6 B

Variable types

Text	6
Categorical	10
Unsupported	1
Numeric	4
Boolean	1
DateTime	1

Alerts

`Card Type` has constant value "Credit"	Constant
`Bank Account Type` has constant value "Checking"	Constant
`Bank Name` has constant value "Bank of Example"	Constant
`AVS Result Code` has constant value "True"	Constant
`CVV Result Code` has constant value "M"	Constant
`Card Brand` is highly overall correlated with `Payment Gateway Name`	High correlation
`Card Last 4 Digits` is highly overall correlated with `Payment Gateway Name`	High correlation
`Gateway Fees` is highly overall correlated with `Net Settled Amount` and 2 other fields	High correlation
`Gateway Response Message` is highly overall correlated with `Net Settled Amount` and 3 other fields	High correlation
`Net Settled Amount` is highly overall correlated with `Gateway Fees` and 3 other fields	High correlation
`Payment Gateway Name` is highly overall correlated with `Card Brand` and 2 other fields	High correlation
`Transaction Amount` is highly overall correlated with `Gateway Fees` and 3 other fields	High correlation
`Transaction Status` is highly overall correlated with `Gateway Response Message` and 1 other fields	High correlation
`Transaction Type` is highly overall correlated with `Gateway Response Message` and 3 other fields	High correlation
`Transaction Status` is highly imbalanced (82.3%)	Imbalance
`Gateway Response Message` is highly imbalanced (68.6%)	Imbalance
`Transaction Type` is highly imbalanced (68.6%)	Imbalance
`Card Brand` has 93954 (66.5%) missing values	Missing
`Card Last 4 Digits` has 93954 (66.5%) missing values	Missing
`Card Type` has 93954 (66.5%) missing values	Missing
`Token ID` has 46844 (33.2%) missing values	Missing
`Bank Account Type` has 94406 (66.8%) missing values	Missing
`Bank Name` has 94406 (66.8%) missing values	Missing
`PayPal Payer ID` has 94140 (66.6%) missing values	Missing
`AVS Result Code` has 93954 (66.5%) missing values	Missing
`CVV Result Code` has 93954 (66.5%) missing values	Missing
`Acquirer Reference Number (ARN)` has 93954 (66.5%) missing values	Missing
`reference_number` has unique values	Unique
`Gateway Response Code` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2025-07-06 23:53:25.569030
Analysis finished	2025-07-06 23:53:31.421588
Duration	5.85 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

Gateway Transaction ID
Text

Distinct	140145
Distinct (%)	99.2%
Missing	0
Missing (%)	0.0%
Memory size	8.5 MiB

Length

Max length	14
Median length	14
Mean length	14
Min length	14

Characters and Unicode

Total characters	1977500
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	139043 ?
Unique (%)	98.4%

Sample

1st row	GW-TRX-9972261
2nd row	GW-TRX-8455695
3rd row	GW-TRX-5184318
4th row	GW-TRX-8104962
5th row	GW-TRX-2770667

Value	Count	Frequency (%)
gw-trx-7907860	3	< 0.1%
gw-trx-7322359	3	< 0.1%
gw-trx-6671195	3	< 0.1%
gw-trx-4056314	2	< 0.1%
gw-trx-2412164	2	< 0.1%
gw-trx-6392152	2	< 0.1%
gw-trx-2151894	2	< 0.1%
gw-trx-9560362	2	< 0.1%
gw-trx-8952714	2	< 0.1%
gw-trx-1465885	2	< 0.1%
Other values (140135)	141227	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
-	282500	14.3%
G	141250	7.1%
W	141250	7.1%
T	141250	7.1%
R	141250	7.1%
X	141250	7.1%
2	101031	5.1%
3	100708	5.1%
4	100656	5.1%
6	100336	5.1%
Other values (6)	586019	29.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1977500	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	282500	14.3%
G	141250	7.1%
W	141250	7.1%
T	141250	7.1%
R	141250	7.1%
X	141250	7.1%
2	101031	5.1%
3	100708	5.1%
4	100656	5.1%
6	100336	5.1%
Other values (6)	586019	29.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1977500	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	282500	14.3%
G	141250	7.1%
W	141250	7.1%
T	141250	7.1%
R	141250	7.1%
X	141250	7.1%
2	101031	5.1%
3	100708	5.1%
4	100656	5.1%
6	100336	5.1%
Other values (6)	586019	29.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1977500	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	282500	14.3%
G	141250	7.1%
W	141250	7.1%
T	141250	7.1%
R	141250	7.1%
X	141250	7.1%
2	101031	5.1%
3	100708	5.1%
4	100656	5.1%
6	100336	5.1%
Other values (6)	586019	29.6%

Payment Gateway Name
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.8 MiB

Cybersource	47296
PayPal	47110
GoCardless	46844

Length

Max length	11
Median length	10
Mean length	9.0007504
Min length	6

Characters and Unicode

Total characters	1271356
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PayPal
2nd row	GoCardless
3rd row	GoCardless
4th row	Cybersource
5th row	PayPal

Common Values

Value	Count	Frequency (%)
Cybersource	47296	33.5%
PayPal	47110	33.4%
GoCardless	46844	33.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
cybersource	47296	33.5%
paypal	47110	33.4%
gocardless	46844	33.2%

Most occurring characters

Value	Count	Frequency (%)
e	141436	11.1%
r	141436	11.1%
a	141064	11.1%
s	140984	11.1%
y	94406	7.4%
P	94220	7.4%
C	94140	7.4%
o	94140	7.4%
l	93954	7.4%
b	47296	3.7%
Other values (4)	188280	14.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1271356	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	141436	11.1%
r	141436	11.1%
a	141064	11.1%
s	140984	11.1%
y	94406	7.4%
P	94220	7.4%
C	94140	7.4%
o	94140	7.4%
l	93954	7.4%
b	47296	3.7%
Other values (4)	188280	14.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1271356	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	141436	11.1%
r	141436	11.1%
a	141064	11.1%
s	140984	11.1%
y	94406	7.4%
P	94220	7.4%
C	94140	7.4%
o	94140	7.4%
l	93954	7.4%
b	47296	3.7%
Other values (4)	188280	14.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1271356	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	141436	11.1%
r	141436	11.1%
a	141064	11.1%
s	140984	11.1%
y	94406	7.4%
P	94220	7.4%
C	94140	7.4%
o	94140	7.4%
l	93954	7.4%
b	47296	3.7%
Other values (4)	188280	14.8%

Transaction Status
Categorical

High correlation Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.5 MiB

settled	137500
disputed	3750

Length

Max length	8
Median length	7
Mean length	7.0265487
Min length	7

Characters and Unicode

Total characters	992500
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	settled
2nd row	settled
3rd row	settled
4th row	settled
5th row	settled

Common Values

Value	Count	Frequency (%)
settled	137500	97.3%
disputed	3750	2.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
settled	137500	97.3%
disputed	3750	2.7%

Most occurring characters

Value	Count	Frequency (%)
e	278750	28.1%
t	278750	28.1%
d	145000	14.6%
s	141250	14.2%
l	137500	13.9%
i	3750	0.4%
p	3750	0.4%
u	3750	0.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	992500	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	278750	28.1%
t	278750	28.1%
d	145000	14.6%
s	141250	14.2%
l	137500	13.9%
i	3750	0.4%
p	3750	0.4%
u	3750	0.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	992500	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	278750	28.1%
t	278750	28.1%
d	145000	14.6%
s	141250	14.2%
l	137500	13.9%
i	3750	0.4%
p	3750	0.4%
u	3750	0.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	992500	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	278750	28.1%
t	278750	28.1%
d	145000	14.6%
s	141250	14.2%
l	137500	13.9%
i	3750	0.4%
p	3750	0.4%
u	3750	0.4%

Gateway Response Code
Unsupported

Rejected Unsupported

Missing	0
Missing (%)	0.0%
Memory size	5.5 MiB

Gateway Response Message
Categorical

High correlation Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.8 MiB

Approved	125000
Refund Processed	12500
Chargeback Initiated	2500
Chargeback Reversed	1250

Length

Max length	20
Median length	8
Mean length	9.0176991
Min length	8

Characters and Unicode

Total characters	1273750
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Approved
2nd row	Approved
3rd row	Approved
4th row	Approved
5th row	Approved

Common Values

Value	Count	Frequency (%)
Approved	125000	88.5%
Refund Processed	12500	8.8%
Chargeback Initiated	2500	1.8%
Chargeback Reversed	1250	0.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
approved	125000	79.4%
refund	12500	7.9%
processed	12500	7.9%
chargeback	3750	2.4%
initiated	2500	1.6%
reversed	1250	0.8%

Most occurring characters

Value	Count	Frequency (%)
p	250000	19.6%
e	172500	13.5%
d	153750	12.1%
r	142500	11.2%
o	137500	10.8%
v	126250	9.9%
A	125000	9.8%
s	26250	2.1%
c	16250	1.3%
	16250	1.3%
Other values (14)	107500	8.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1273750	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
p	250000	19.6%
e	172500	13.5%
d	153750	12.1%
r	142500	11.2%
o	137500	10.8%
v	126250	9.9%
A	125000	9.8%
s	26250	2.1%
c	16250	1.3%
	16250	1.3%
Other values (14)	107500	8.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1273750	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
p	250000	19.6%
e	172500	13.5%
d	153750	12.1%
r	142500	11.2%
o	137500	10.8%
v	126250	9.9%
A	125000	9.8%
s	26250	2.1%
c	16250	1.3%
	16250	1.3%
Other values (14)	107500	8.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1273750	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
p	250000	19.6%
e	172500	13.5%
d	153750	12.1%
r	142500	11.2%
o	137500	10.8%
v	126250	9.9%
A	125000	9.8%
s	26250	2.1%
c	16250	1.3%
	16250	1.3%
Other values (14)	107500	8.4%

Transaction Amount
Real number (ℝ)

High correlation

Distinct	122801
Distinct (%)	86.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1979.2208

Minimum	-4999.85
Maximum	4999.87
Zeros	0
Zeros (%)	0.0%
Negative	15000
Negative (%)	10.6%
Memory size	1.1 MiB

Quantile statistics

Minimum	-4999.85
5-th percentile	-2655.288
Q1	828.465
median	2221.17
Q3	3607.4425
95-th percentile	4724.491
Maximum	4999.87
Range	9999.72
Interquartile range (IQR)	2778.9775

Descriptive statistics

Standard deviation	2112.685
Coefficient of variation (CV)	1.0674327
Kurtosis	1.0466637
Mean	1979.2208
Median Absolute Deviation (MAD)	1389.74
Skewness	-1.0062879
Sum	2.7956493 × 10⁸
Variance	4463437.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4756.12	5	< 0.1%
953.97	5	< 0.1%
931.3	5	< 0.1%
3543.24	5	< 0.1%
4146.9	5	< 0.1%
1020.37	5	< 0.1%
1902	5	< 0.1%
2595.9	5	< 0.1%
1121	4	< 0.1%
4540.24	4	< 0.1%
Other values (122791)	141202	> 99.9%

Value	Count	Frequency (%)
-4999.85	1	< 0.1%
-4999.06	1	< 0.1%
-4998.84	2	< 0.1%
-4998.76	1	< 0.1%
-4998.23	1	< 0.1%
-4996.55	2	< 0.1%
-4996.24	1	< 0.1%
-4996.23	2	< 0.1%
-4996.21	2	< 0.1%
-4995.93	1	< 0.1%

Value	Count	Frequency (%)
4999.87	1	< 0.1%
4999.85	2	< 0.1%
4999.66	1	< 0.1%
4999.61	1	< 0.1%
4999.54	1	< 0.1%
4999.44	1	< 0.1%
4999.28	2	< 0.1%
4999.27	1	< 0.1%
4999.26	1	< 0.1%
4999.24	1	< 0.1%

Transaction Currency
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.0 MiB

USD	84784
EUR	21002
GBP	14100
AUD	11416
CAD	9948

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	423750
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	USD
2nd row	USD
3rd row	USD
4th row	GBP
5th row	USD

Common Values

Value	Count	Frequency (%)
USD	84784	60.0%
EUR	21002	14.9%
GBP	14100	10.0%
AUD	11416	8.1%
CAD	9948	7.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
usd	84784	60.0%
eur	21002	14.9%
gbp	14100	10.0%
aud	11416	8.1%
cad	9948	7.0%

Most occurring characters

Value	Count	Frequency (%)
U	117202	27.7%
D	106148	25.0%
S	84784	20.0%
A	21364	5.0%
E	21002	5.0%
R	21002	5.0%
G	14100	3.3%
B	14100	3.3%
P	14100	3.3%
C	9948	2.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	423750	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
U	117202	27.7%
D	106148	25.0%
S	84784	20.0%
A	21364	5.0%
E	21002	5.0%
R	21002	5.0%
G	14100	3.3%
B	14100	3.3%
P	14100	3.3%
C	9948	2.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	423750	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
U	117202	27.7%
D	106148	25.0%
S	84784	20.0%
A	21364	5.0%
E	21002	5.0%
R	21002	5.0%
G	14100	3.3%
B	14100	3.3%
P	14100	3.3%
C	9948	2.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	423750	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
U	117202	27.7%
D	106148	25.0%
S	84784	20.0%
A	21364	5.0%
E	21002	5.0%
R	21002	5.0%
G	14100	3.3%
B	14100	3.3%
P	14100	3.3%
C	9948	2.3%

Transaction Type
Categorical

High correlation Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

payment	125000
refund	12500
chargeback	2500
chargeback_reversal	1250

Length

Max length	19
Median length	7
Mean length	7.0707965
Min length	6

Characters and Unicode

Total characters	998750
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	payment
2nd row	payment
3rd row	payment
4th row	payment
5th row	payment

Common Values

Value	Count	Frequency (%)
payment	125000	88.5%
refund	12500	8.8%
chargeback	2500	1.8%
chargeback_reversal	1250	0.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
payment	125000	88.5%
refund	12500	8.8%
chargeback	2500	1.8%
chargeback_reversal	1250	0.9%

Most occurring characters

Value	Count	Frequency (%)
e	143750	14.4%
n	137500	13.8%
a	133750	13.4%
p	125000	12.5%
y	125000	12.5%
m	125000	12.5%
t	125000	12.5%
r	18750	1.9%
u	12500	1.3%
d	12500	1.3%
Other values (10)	40000	4.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	998750	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	143750	14.4%
n	137500	13.8%
a	133750	13.4%
p	125000	12.5%
y	125000	12.5%
m	125000	12.5%
t	125000	12.5%
r	18750	1.9%
u	12500	1.3%
d	12500	1.3%
Other values (10)	40000	4.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	998750	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	143750	14.4%
n	137500	13.8%
a	133750	13.4%
p	125000	12.5%
y	125000	12.5%
m	125000	12.5%
t	125000	12.5%
r	18750	1.9%
u	12500	1.3%
d	12500	1.3%
Other values (10)	40000	4.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	998750	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	143750	14.4%
n	137500	13.8%
a	133750	13.4%
p	125000	12.5%
y	125000	12.5%
m	125000	12.5%
t	125000	12.5%
r	18750	1.9%
u	12500	1.3%
d	12500	1.3%
Other values (10)	40000	4.0%

Card Brand
Categorical

High correlation Missing

Distinct	3
Distinct (%)	< 0.1%
Missing	93954
Missing (%)	66.5%
Memory size	7.5 MiB

Mastercard	15960
Visa	15697
Amex	15639

Length

Max length	10
Median length	4
Mean length	6.0246955
Min length	4

Characters and Unicode

Total characters	284944
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Visa
2nd row	Mastercard
3rd row	Amex
4th row	Mastercard
5th row	Visa

Common Values

Value	Count	Frequency (%)
Mastercard	15960	11.3%
Visa	15697	11.1%
Amex	15639	11.1%
(Missing)	93954	66.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
mastercard	15960	33.7%
visa	15697	33.2%
amex	15639	33.1%

Most occurring characters

Value	Count	Frequency (%)
a	47617	16.7%
r	31920	11.2%
s	31657	11.1%
e	31599	11.1%
M	15960	5.6%
t	15960	5.6%
c	15960	5.6%
d	15960	5.6%
V	15697	5.5%
i	15697	5.5%
Other values (3)	46917	16.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	284944	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	47617	16.7%
r	31920	11.2%
s	31657	11.1%
e	31599	11.1%
M	15960	5.6%
t	15960	5.6%
c	15960	5.6%
d	15960	5.6%
V	15697	5.5%
i	15697	5.5%
Other values (3)	46917	16.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	284944	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	47617	16.7%
r	31920	11.2%
s	31657	11.1%
e	31599	11.1%
M	15960	5.6%
t	15960	5.6%
c	15960	5.6%
d	15960	5.6%
V	15697	5.5%
i	15697	5.5%
Other values (3)	46917	16.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	284944	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	47617	16.7%
r	31920	11.2%
s	31657	11.1%
e	31599	11.1%
M	15960	5.6%
t	15960	5.6%
c	15960	5.6%
d	15960	5.6%
V	15697	5.5%
i	15697	5.5%
Other values (3)	46917	16.5%

Card Last 4 Digits
Real number (ℝ)

High correlation Missing

Distinct	8963
Distinct (%)	19.0%
Missing	93954
Missing (%)	66.5%
Infinite	0
Infinite (%)	0.0%
Mean	5511.9391

Minimum	1000
Maximum	9999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	1000
5-th percentile	1459.75
Q1	3267
median	5540.5
Q3	7743.25
95-th percentile	9541
Maximum	9999
Range	8999
Interquartile range (IQR)	4476.25

Descriptive statistics

Standard deviation	2588.5975
Coefficient of variation (CV)	0.46963463
Kurtosis	-1.1929835
Mean	5511.9391
Median Absolute Deviation (MAD)	2238.5
Skewness	-0.0087537714
Sum	2.6069267 × 10⁸
Variance	6700836.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5062	16	< 0.1%
2609	15	< 0.1%
9615	15	< 0.1%
9126	15	< 0.1%
9930	15	< 0.1%
7952	14	< 0.1%
6197	14	< 0.1%
4571	14	< 0.1%
3207	14	< 0.1%
3872	14	< 0.1%
Other values (8953)	47150	33.4%
(Missing)	93954	66.5%

Value	Count	Frequency (%)
1000	3	< 0.1%
1001	4	< 0.1%
1002	3	< 0.1%
1003	4	< 0.1%
1004	3	< 0.1%
1005	5	< 0.1%
1006	7	< 0.1%
1007	5	< 0.1%
1008	3	< 0.1%
1009	6	< 0.1%

Value	Count	Frequency (%)
9999	7	< 0.1%
9998	8	< 0.1%
9997	7	< 0.1%
9996	5	< 0.1%
9995	5	< 0.1%
9994	6	< 0.1%
9993	5	< 0.1%
9992	7	< 0.1%
9991	8	< 0.1%
9990	7	< 0.1%

Card Type
Categorical

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	93954
Missing (%)	66.5%
Memory size	7.5 MiB

Credit	47296

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	283776
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Credit
2nd row	Credit
3rd row	Credit
4th row	Credit
5th row	Credit

Common Values

Value	Count	Frequency (%)
Credit	47296	33.5%
(Missing)	93954	66.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
credit	47296	100.0%

Most occurring characters

Value	Count	Frequency (%)
C	47296	16.7%
r	47296	16.7%
e	47296	16.7%
d	47296	16.7%
i	47296	16.7%
t	47296	16.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	283776	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
C	47296	16.7%
r	47296	16.7%
e	47296	16.7%
d	47296	16.7%
i	47296	16.7%
t	47296	16.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	283776	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
C	47296	16.7%
r	47296	16.7%
e	47296	16.7%
d	47296	16.7%
i	47296	16.7%
t	47296	16.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	283776	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
C	47296	16.7%
r	47296	16.7%
e	47296	16.7%
d	47296	16.7%
i	47296	16.7%
t	47296	16.7%

Token ID
Text

Missing

Distinct	89597
Distinct (%)	94.9%
Missing	46844
Missing (%)	33.2%
Memory size	6.7 MiB

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	944060
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	84954 ?
Unique (%)	90.0%

Sample

1st row	TOK_850912
2nd row	TOK_268155
3rd row	TOK_866077
4th row	TOK_244127
5th row	TOK_513827

Value	Count	Frequency (%)
tok_962548	4	< 0.1%
tok_646979	4	< 0.1%
tok_257937	4	< 0.1%
tok_974943	4	< 0.1%
tok_820511	4	< 0.1%
tok_973529	4	< 0.1%
tok_769620	4	< 0.1%
tok_426828	3	< 0.1%
tok_848212	3	< 0.1%
tok_265257	3	< 0.1%
Other values (89587)	94369	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
T	94406	10.0%
O	94406	10.0%
K	94406	10.0%
_	94406	10.0%
4	58303	6.2%
2	57878	6.1%
7	57825	6.1%
1	57804	6.1%
9	57751	6.1%
8	57626	6.1%
Other values (4)	219249	23.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	944060	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
T	94406	10.0%
O	94406	10.0%
K	94406	10.0%
_	94406	10.0%
4	58303	6.2%
2	57878	6.1%
7	57825	6.1%
1	57804	6.1%
9	57751	6.1%
8	57626	6.1%
Other values (4)	219249	23.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	944060	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
T	94406	10.0%
O	94406	10.0%
K	94406	10.0%
_	94406	10.0%
4	58303	6.2%
2	57878	6.1%
7	57825	6.1%
1	57804	6.1%
9	57751	6.1%
8	57626	6.1%
Other values (4)	219249	23.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	944060	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
T	94406	10.0%
O	94406	10.0%
K	94406	10.0%
_	94406	10.0%
4	58303	6.2%
2	57878	6.1%
7	57825	6.1%
1	57804	6.1%
9	57751	6.1%
8	57626	6.1%
Other values (4)	219249	23.2%

Bank Account Type
Categorical

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	94406
Missing (%)	66.8%
Memory size	7.6 MiB

Checking	46844

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	374752
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Checking
2nd row	Checking
3rd row	Checking
4th row	Checking
5th row	Checking

Common Values

Value	Count	Frequency (%)
Checking	46844	33.2%
(Missing)	94406	66.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
checking	46844	100.0%

Most occurring characters

Value	Count	Frequency (%)
C	46844	12.5%
h	46844	12.5%
e	46844	12.5%
c	46844	12.5%
k	46844	12.5%
i	46844	12.5%
n	46844	12.5%
g	46844	12.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	374752	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
C	46844	12.5%
h	46844	12.5%
e	46844	12.5%
c	46844	12.5%
k	46844	12.5%
i	46844	12.5%
n	46844	12.5%
g	46844	12.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	374752	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
C	46844	12.5%
h	46844	12.5%
e	46844	12.5%
c	46844	12.5%
k	46844	12.5%
i	46844	12.5%
n	46844	12.5%
g	46844	12.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	374752	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
C	46844	12.5%
h	46844	12.5%
e	46844	12.5%
c	46844	12.5%
k	46844	12.5%
i	46844	12.5%
n	46844	12.5%
g	46844	12.5%

Bank Name
Categorical

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	94406
Missing (%)	66.8%
Memory size	7.9 MiB

Bank of Example	46844

Length

Max length	15
Median length	15
Mean length	15
Min length	15

Characters and Unicode

Total characters	702660
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Bank of Example
2nd row	Bank of Example
3rd row	Bank of Example
4th row	Bank of Example
5th row	Bank of Example

Common Values

Value	Count	Frequency (%)
Bank of Example	46844	33.2%
(Missing)	94406	66.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
bank	46844	33.3%
of	46844	33.3%
example	46844	33.3%

Most occurring characters

Value	Count	Frequency (%)
a	93688	13.3%
	93688	13.3%
B	46844	6.7%
n	46844	6.7%
k	46844	6.7%
o	46844	6.7%
f	46844	6.7%
E	46844	6.7%
x	46844	6.7%
m	46844	6.7%
Other values (3)	140532	20.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	702660	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	93688	13.3%
	93688	13.3%
B	46844	6.7%
n	46844	6.7%
k	46844	6.7%
o	46844	6.7%
f	46844	6.7%
E	46844	6.7%
x	46844	6.7%
m	46844	6.7%
Other values (3)	140532	20.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	702660	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	93688	13.3%
	93688	13.3%
B	46844	6.7%
n	46844	6.7%
k	46844	6.7%
o	46844	6.7%
f	46844	6.7%
E	46844	6.7%
x	46844	6.7%
m	46844	6.7%
Other values (3)	140532	20.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	702660	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	93688	13.3%
	93688	13.3%
B	46844	6.7%
n	46844	6.7%
k	46844	6.7%
o	46844	6.7%
f	46844	6.7%
E	46844	6.7%
x	46844	6.7%
m	46844	6.7%
Other values (3)	140532	20.0%

PayPal Payer ID
Text

Missing

Distinct	36639
Distinct (%)	77.8%
Missing	94140
Missing (%)	66.6%
Memory size	5.6 MiB

Length

Max length	12
Median length	12
Mean length	12
Min length	12

Characters and Unicode

Total characters	565320
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	27837 ?
Unique (%)	59.1%

Sample

1st row	PAYPAL_68156
2nd row	PAYPAL_39472
3rd row	PAYPAL_70561
4th row	PAYPAL_58053
5th row	PAYPAL_14028

Value	Count	Frequency (%)
paypal_74333	6	< 0.1%
paypal_64956	6	< 0.1%
paypal_34329	6	< 0.1%
paypal_85624	6	< 0.1%
paypal_91684	6	< 0.1%
paypal_64341	5	< 0.1%
paypal_67055	5	< 0.1%
paypal_57454	5	< 0.1%
paypal_60070	5	< 0.1%
paypal_14087	5	< 0.1%
Other values (36629)	47055	99.9%

Most occurring characters

Value	Count	Frequency (%)
P	94220	16.7%
A	94220	16.7%
Y	47110	8.3%
L	47110	8.3%
_	47110	8.3%
6	24334	4.3%
1	24257	4.3%
7	24129	4.3%
9	24071	4.3%
2	24058	4.3%
Other values (5)	114701	20.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	565320	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
P	94220	16.7%
A	94220	16.7%
Y	47110	8.3%
L	47110	8.3%
_	47110	8.3%
6	24334	4.3%
1	24257	4.3%
7	24129	4.3%
9	24071	4.3%
2	24058	4.3%
Other values (5)	114701	20.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	565320	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
P	94220	16.7%
A	94220	16.7%
Y	47110	8.3%
L	47110	8.3%
_	47110	8.3%
6	24334	4.3%
1	24257	4.3%
7	24129	4.3%
9	24071	4.3%
2	24058	4.3%
Other values (5)	114701	20.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	565320	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
P	94220	16.7%
A	94220	16.7%
Y	47110	8.3%
L	47110	8.3%
_	47110	8.3%
6	24334	4.3%
1	24257	4.3%
7	24129	4.3%
9	24071	4.3%
2	24058	4.3%
Other values (5)	114701	20.3%

AVS Result Code
Boolean

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	93954
Missing (%)	66.5%
Memory size	276.0 KiB

True	47296
(Missing)	93954

Value	Count	Frequency (%)
True	47296	33.5%
(Missing)	93954	66.5%

CVV Result Code
Categorical

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	93954
Missing (%)	66.5%
Memory size	7.3 MiB

M	47296

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	47296
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	M
2nd row	M
3rd row	M
4th row	M
5th row	M

Common Values

Value	Count	Frequency (%)
M	47296	33.5%
(Missing)	93954	66.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
m	47296	100.0%

Most occurring characters

Value	Count	Frequency (%)
M	47296	100.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	47296	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
M	47296	100.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	47296	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
M	47296	100.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	47296	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
M	47296	100.0%

Authorization Code
Text

Distinct	130917
Distinct (%)	92.7%
Missing	0
Missing (%)	0.0%
Memory size	7.9 MiB

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	1412500
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	121088 ?
Unique (%)	85.7%

Sample

1st row	AUTH698092
2nd row	AUTH259525
3rd row	AUTH662545
4th row	AUTH779374
5th row	AUTH375526

Value	Count	Frequency (%)
auth479890	4	< 0.1%
auth627885	4	< 0.1%
auth181464	4	< 0.1%
auth685219	4	< 0.1%
auth776662	4	< 0.1%
auth571739	4	< 0.1%
auth344919	4	< 0.1%
auth963043	4	< 0.1%
auth813614	4	< 0.1%
auth682755	4	< 0.1%
Other values (130907)	141210	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
A	141250	10.0%
U	141250	10.0%
T	141250	10.0%
H	141250	10.0%
9	86690	6.1%
8	86510	6.1%
3	86496	6.1%
2	86448	6.1%
6	86364	6.1%
1	86225	6.1%
Other values (4)	328767	23.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1412500	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	141250	10.0%
U	141250	10.0%
T	141250	10.0%
H	141250	10.0%
9	86690	6.1%
8	86510	6.1%
3	86496	6.1%
2	86448	6.1%
6	86364	6.1%
1	86225	6.1%
Other values (4)	328767	23.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1412500	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	141250	10.0%
U	141250	10.0%
T	141250	10.0%
H	141250	10.0%
9	86690	6.1%
8	86510	6.1%
3	86496	6.1%
2	86448	6.1%
6	86364	6.1%
1	86225	6.1%
Other values (4)	328767	23.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1412500	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	141250	10.0%
U	141250	10.0%
T	141250	10.0%
H	141250	10.0%
9	86690	6.1%
8	86510	6.1%
3	86496	6.1%
2	86448	6.1%
6	86364	6.1%
1	86225	6.1%
Other values (4)	328767	23.3%

Gateway Timestamp
Date

Distinct	90
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Minimum	2025-01-01 00:00:00
Maximum	2025-03-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Gateway Fees
Real number (ℝ)

High correlation

Distinct	4995
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.796576

Minimum	0.06
Maximum	50
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0.06
5-th percentile	1.29
Q1	6.03
median	11.95
Q3	26.94
95-th percentile	42.63
Maximum	50
Range	49.94
Interquartile range (IQR)	20.91

Descriptive statistics

Standard deviation	13.173946
Coefficient of variation (CV)	0.78432333
Kurtosis	-0.60008441
Mean	16.796576
Median Absolute Deviation (MAD)	8.4
Skewness	0.71942814
Sum	2372516.3
Variance	173.55286
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10.64	92	0.1%
4.84	89	0.1%
3.19	85	0.1%
3.94	85	0.1%
6.85	84	0.1%
7.99	84	0.1%
7.95	83	0.1%
5.61	83	0.1%
1.07	83	0.1%
5.52	83	0.1%
Other values (4985)	140399	99.4%

Value	Count	Frequency (%)
0.06	12	< 0.1%
0.07	36	< 0.1%
0.08	48	< 0.1%
0.09	30	< 0.1%
0.1	38	< 0.1%
0.11	42	< 0.1%
0.12	46	< 0.1%
0.13	35	< 0.1%
0.14	38	< 0.1%
0.15	42	< 0.1%

Value	Count	Frequency (%)
50	2	< 0.1%
49.99	6	< 0.1%
49.98	6	< 0.1%
49.97	4	< 0.1%
49.96	14	< 0.1%
49.95	12	< 0.1%
49.94	10	< 0.1%
49.93	15	< 0.1%
49.92	6	< 0.1%
49.91	6	< 0.1%

Net Settled Amount
Real number (ℝ)

High correlation

Distinct	124790
Distinct (%)	88.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1962.4242

Minimum	-5046.2
Maximum	4987.37
Zeros	0
Zeros (%)	0.0%
Negative	15000
Negative (%)	10.6%
Memory size	1.1 MiB

Quantile statistics

Minimum	-5046.2
5-th percentile	-2672.5785
Q1	822.68
median	2206.12
Q3	3583.4875
95-th percentile	4692.4065
Maximum	4987.37
Range	10033.57
Interquartile range (IQR)	2760.8075

Descriptive statistics

Standard deviation	2107.6026
Coefficient of variation (CV)	1.0739791
Kurtosis	1.0941128
Mean	1962.4242
Median Absolute Deviation (MAD)	1380.015
Skewness	-1.0220654
Sum	2.7719242 × 10⁸
Variance	4441988.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3385.57	5	< 0.1%
3300.21	5	< 0.1%
2897.74	5	< 0.1%
4796.47	5	< 0.1%
2508.85	4	< 0.1%
740.26	4	< 0.1%
1054.78	4	< 0.1%
1727.27	4	< 0.1%
2273.48	4	< 0.1%
1768.97	4	< 0.1%
Other values (124780)	141206	> 99.9%

Value	Count	Frequency (%)
-5046.2	1	< 0.1%
-5045.89	1	< 0.1%
-5045.17	1	< 0.1%
-5044.44	1	< 0.1%
-5044.03	1	< 0.1%
-5042.96	1	< 0.1%
-5042.84	1	< 0.1%
-5042.64	1	< 0.1%
-5039.5	1	< 0.1%
-5039.08	1	< 0.1%

Value	Count	Frequency (%)
4987.37	1	< 0.1%
4987.35	1	< 0.1%
4987.11	1	< 0.1%
4987.04	1	< 0.1%
4986.94	1	< 0.1%
4986.78	2	< 0.1%
4986.68	1	< 0.1%
4986.35	1	< 0.1%
4986.34	1	< 0.1%
4986.23	1	< 0.1%

Acquirer Reference Number (ARN)
Text

Missing

Distinct	47296
Distinct (%)	100.0%
Missing	93954
Missing (%)	66.5%
Memory size	5.6 MiB

Length

Max length	12
Median length	12
Mean length	12
Min length	12

Characters and Unicode

Total characters	567552
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	47296 ?
Unique (%)	100.0%

Sample

1st row	ARN618188908
2nd row	ARN591055160
3rd row	ARN184492302
4th row	ARN314680266
5th row	ARN615595718

Value	Count	Frequency (%)
arn276300877	1	< 0.1%
arn213177541	1	< 0.1%
arn669849388	1	< 0.1%
arn629677896	1	< 0.1%
arn591055160	1	< 0.1%
arn184492302	1	< 0.1%
arn314680266	1	< 0.1%
arn615595718	1	< 0.1%
arn594832966	1	< 0.1%
arn508354528	1	< 0.1%
Other values (47286)	47286	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
A	47296	8.3%
R	47296	8.3%
N	47296	8.3%
2	43333	7.6%
3	43163	7.6%
6	43124	7.6%
7	43103	7.6%
9	43094	7.6%
5	43048	7.6%
8	43038	7.6%
Other values (3)	123761	21.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	567552	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	47296	8.3%
R	47296	8.3%
N	47296	8.3%
2	43333	7.6%
3	43163	7.6%
6	43124	7.6%
7	43103	7.6%
9	43094	7.6%
5	43048	7.6%
8	43038	7.6%
Other values (3)	123761	21.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	567552	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	47296	8.3%
R	47296	8.3%
N	47296	8.3%
2	43333	7.6%
3	43163	7.6%
6	43124	7.6%
7	43103	7.6%
9	43094	7.6%
5	43048	7.6%
8	43038	7.6%
Other values (3)	123761	21.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	567552	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	47296	8.3%
R	47296	8.3%
N	47296	8.3%
2	43333	7.6%
3	43163	7.6%
6	43124	7.6%
7	43103	7.6%
9	43094	7.6%
5	43048	7.6%
8	43038	7.6%
Other values (3)	123761	21.8%

reference_number
Text

Unique

Distinct	141250
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	8.1 MiB

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	1553750
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	141250 ?
Unique (%)	100.0%

Sample

1st row	PAY-0000000
2nd row	PAY-0000001
3rd row	PAY-0000002
4th row	PAY-0000003
5th row	PAY-0000004

Value	Count	Frequency (%)
pay-0000000	1	< 0.1%
pay-0000011	1	< 0.1%
pay-0000017	1	< 0.1%
pay-0000016	1	< 0.1%
pay-0000015	1	< 0.1%
pay-0000014	1	< 0.1%
pay-0000013	1	< 0.1%
pay-0000012	1	< 0.1%
pay-0000010	1	< 0.1%
pay-0000070	1	< 0.1%
Other values (141240)	141240	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
0	334091	21.5%
-	141250	9.1%
P	125000	8.0%
Y	125000	8.0%
A	125000	8.0%
1	107672	6.9%
2	73838	4.8%
4	68511	4.4%
3	68239	4.4%
5	67331	4.3%
Other values (11)	317818	20.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1553750	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	334091	21.5%
-	141250	9.1%
P	125000	8.0%
Y	125000	8.0%
A	125000	8.0%
1	107672	6.9%
2	73838	4.8%
4	68511	4.4%
3	68239	4.4%
5	67331	4.3%
Other values (11)	317818	20.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1553750	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	334091	21.5%
-	141250	9.1%
P	125000	8.0%
Y	125000	8.0%
A	125000	8.0%
1	107672	6.9%
2	73838	4.8%
4	68511	4.4%
3	68239	4.4%
5	67331	4.3%
Other values (11)	317818	20.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1553750	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	334091	21.5%
-	141250	9.1%
P	125000	8.0%
Y	125000	8.0%
A	125000	8.0%
1	107672	6.9%
2	73838	4.8%
4	68511	4.4%
3	68239	4.4%
5	67331	4.3%
Other values (11)	317818	20.5%

Interactions

Correlations

	Card Brand	Card Last 4 Digits	Gateway Fees	Gateway Response Message	Net Settled Amount	Payment Gateway Name	Transaction Amount	Transaction Currency	Transaction Status	Transaction Type
Card Brand	1.000	0.000	0.013	0.000	0.012	1.000	0.012	0.006	0.000	0.000
Card Last 4 Digits	0.000	1.000	0.004	0.000	0.005	1.000	0.005	0.000	0.000	0.000
Gateway Fees	0.013	0.004	1.000	0.000	0.594	0.508	0.597	0.004	0.001	0.000
Gateway Response Message	0.000	0.000	0.000	1.000	0.577	0.000	0.577	0.000	1.000	1.000
Net Settled Amount	0.012	0.005	0.594	0.577	1.000	0.000	1.000	0.004	0.300	0.577
Payment Gateway Name	1.000	1.000	0.508	0.000	0.000	1.000	0.000	0.000	0.005	0.000
Transaction Amount	0.012	0.005	0.597	0.577	1.000	0.000	1.000	0.004	0.301	0.577
Transaction Currency	0.006	0.000	0.004	0.000	0.004	0.000	0.004	1.000	0.000	0.000
Transaction Status	0.000	0.000	0.001	1.000	0.300	0.005	0.301	0.000	1.000	1.000
Transaction Type	0.000	0.000	0.000	1.000	0.577	0.000	0.577	0.000	1.000	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	Gateway Transaction ID	Payment Gateway Name	Transaction Status	Gateway Response Message	Transaction Amount	Transaction Currency	Transaction Type	Card Brand	Card Last 4 Digits	Card Type	Token ID	Bank Account Type	Bank Name	PayPal Payer ID	AVS Result Code	CVV Result Code	Authorization Code	Gateway Timestamp	Gateway Fees	Net Settled Amount	Acquirer Reference Number (ARN)	reference_number
0	GW-TRX-9972261	PayPal	settled	Approved	2592.98	USD	payment	NaN	NaN	NaN	TOK_850912	NaN	NaN	PAYPAL_68156	NaN	NaN	AUTH698092	2025-01-30	19.45	2573.53	NaN	PAY-0000000
1	GW-TRX-8455695	GoCardless	settled	Approved	4277.28	USD	payment	NaN	NaN	NaN	NaN	Checking	Bank of Example	NaN	NaN	NaN	AUTH259525	2025-01-10	10.69	4266.59	NaN	PAY-0000001
2	GW-TRX-5184318	GoCardless	settled	Approved	2515.78	USD	payment	NaN	NaN	NaN	NaN	Checking	Bank of Example	NaN	NaN	NaN	AUTH662545	2025-02-21	6.29	2509.49	NaN	PAY-0000002
3	GW-TRX-8104962	Cybersource	settled	Approved	2874.81	GBP	payment	Visa	9887.0	Credit	TOK_268155	NaN	NaN	NaN	Y	M	AUTH779374	2025-01-04	28.75	2846.06	ARN618188908	PAY-0000003
4	GW-TRX-2770667	PayPal	settled	Approved	350.01	USD	payment	NaN	NaN	NaN	TOK_866077	NaN	NaN	PAYPAL_39472	NaN	NaN	AUTH375526	2025-03-16	2.63	347.38	NaN	PAY-0000004
5	GW-TRX-8558984	Cybersource	settled	Approved	4412.91	USD	payment	Mastercard	9534.0	Credit	TOK_244127	NaN	NaN	NaN	Y	M	AUTH730663	2025-02-10	44.13	4368.78	ARN591055160	PAY-0000005
6	GW-TRX-5053867	GoCardless	settled	Approved	399.15	AUD	payment	NaN	NaN	NaN	NaN	Checking	Bank of Example	NaN	NaN	NaN	AUTH539557	2025-02-07	1.00	398.15	NaN	PAY-0000006
7	GW-TRX-1689560	GoCardless	settled	Approved	1639.12	GBP	payment	NaN	NaN	NaN	NaN	Checking	Bank of Example	NaN	NaN	NaN	AUTH580595	2025-02-20	4.10	1635.02	NaN	PAY-0000007
8	GW-TRX-5187601	Cybersource	settled	Approved	802.45	USD	payment	Amex	2535.0	Credit	TOK_513827	NaN	NaN	NaN	Y	M	AUTH122940	2025-02-25	8.02	794.43	ARN184492302	PAY-0000008
9	GW-TRX-8963563	Cybersource	settled	Approved	4780.71	USD	payment	Mastercard	6108.0	Credit	TOK_505369	NaN	NaN	NaN	Y	M	AUTH575960	2025-02-23	47.81	4732.90	ARN314680266	PAY-0000009

	Gateway Transaction ID	Payment Gateway Name	Transaction Status	Gateway Response Code	Gateway Response Message	Transaction Amount	Transaction Currency	Transaction Type	Card Brand	Card Last 4 Digits	Card Type	Token ID	Bank Account Type	Bank Name	PayPal Payer ID	AVS Result Code	CVV Result Code	Authorization Code	Gateway Timestamp	Gateway Fees	Net Settled Amount	Acquirer Reference Number (ARN)	reference_number
141240	GW-TRX-8740287	GoCardless	disputed	C02	Chargeback Reversed	689.24	USD	chargeback_reversal	NaN	NaN	NaN	NaN	Checking	Bank of Example	NaN	NaN	NaN	AUTH406341	2025-03-26	1.72	687.52	NaN	REV-0107910
141241	GW-TRX-2880464	Cybersource	disputed	C02	Chargeback Reversed	2318.44	USD	chargeback_reversal	Mastercard	5928.0	Credit	TOK_629291	NaN	NaN	NaN	Y	M	AUTH545329	2025-03-06	23.18	2295.26	ARN263111260	REV-0024103
141242	GW-TRX-8746072	Cybersource	disputed	C02	Chargeback Reversed	4353.13	CAD	chargeback_reversal	Amex	8590.0	Credit	TOK_952318	NaN	NaN	NaN	Y	M	AUTH106225	2025-03-11	43.53	4309.60	ARN135414927	REV-0039969
141243	GW-TRX-9992588	PayPal	disputed	C02	Chargeback Reversed	28.61	GBP	chargeback_reversal	NaN	NaN	NaN	TOK_718010	NaN	NaN	PAYPAL_61698	NaN	NaN	AUTH401048	2025-01-31	0.21	28.40	NaN	REV-0101060
141244	GW-TRX-4931445	GoCardless	disputed	C02	Chargeback Reversed	2263.30	USD	chargeback_reversal	NaN	NaN	NaN	NaN	Checking	Bank of Example	NaN	NaN	NaN	AUTH580522	2025-01-24	5.66	2257.64	NaN	REV-0020178
141245	GW-TRX-3674175	GoCardless	disputed	C02	Chargeback Reversed	2573.44	USD	chargeback_reversal	NaN	NaN	NaN	NaN	Checking	Bank of Example	NaN	NaN	NaN	AUTH488942	2025-03-12	6.43	2567.01	NaN	REV-0025245
141246	GW-TRX-7067200	Cybersource	disputed	C02	Chargeback Reversed	794.03	EUR	chargeback_reversal	Amex	8120.0	Credit	TOK_778198	NaN	NaN	NaN	Y	M	AUTH370822	2025-01-01	7.94	786.09	ARN131111169	REV-0093761
141247	GW-TRX-1013476	PayPal	disputed	C02	Chargeback Reversed	3629.53	USD	chargeback_reversal	NaN	NaN	NaN	TOK_797724	NaN	NaN	PAYPAL_12773	NaN	NaN	AUTH463738	2025-02-13	27.22	3602.31	NaN	REV-0103102
141248	GW-TRX-4629535	Cybersource	disputed	C02	Chargeback Reversed	2700.28	USD	chargeback_reversal	Mastercard	8696.0	Credit	TOK_890568	NaN	NaN	NaN	Y	M	AUTH300557	2025-02-10	27.00	2673.28	ARN894657558	REV-0039089
141249	GW-TRX-7889594	GoCardless	disputed	C02	Chargeback Reversed	2500.12	CAD	chargeback_reversal	NaN	NaN	NaN	NaN	Checking	Bank of Example	NaN	NaN	NaN	AUTH961626	2025-01-05	6.25	2493.87	NaN	REV-0022422

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)